package com.maxMgmt.Constants;

public class QueryConstants {

	//---------Address
	
	public static final String INSERT_ADDRESS = 
		"INSERT INTO TBL_ADDRESS (ADDR_ID,ADDR1,ADDR2,CITY,STATE,PINCODE)" +
		"VALUES (?,?,?,?,?,?)";
	
	public static final String UPDATE_ADDRESS = 
		"UPDATE TBL_ADDRESS ADDR_ID = ?,ADDR1 = ?,ADDR2 = ?,CITY = ?," +
		"STATE = ?,PINCODE = ? WHERE ADDR_ID = ?";
	
	public static final String DELETE_ADDRESS = 
		"DELETE FROM TBL_ADDRESS WHERE ADDR_ID = ?";
	
	public static final String SELECT_ADDRESS = 
		"SELECT * FROM TBL_ADDRESS WHERE ADDR_ID = ?";
	
	//---------Doct Types
	
	public static final String INSERT_DOCT_TYPES = 
		"INSERT INTO TBL_DOCT_TYPES (DOCT_TYPE_ID,DOCT_TYPE_NAME)" +
		"VALUES (?,?)";
	
	public static final String UPDATE_DOCT_TYPES = 
		"UPDATE TBL_DOCT_TYPES DOCT_TYPE_ID = ?,DOCT_TYPE_NAME = ? WHERE DOCT_TYPE_ID = ?";
	
	public static final String DELETE_DOCT_TYPES = 
		"DELETE FROM TBL_DOCT_TYPES WHERE DOCT_TYPE_ID = ?";
	
	public static final String SELECT_DOCT_TYPES = 
		"SELECT * FROM TBL_DOCT_TYPES WHERE DOCT_TYPE_ID = ?";
	
	public static final String SELECT_ALL_DOCT_TYPES = 
		"SELECT * FROM TBL_DOCT_TYPES";
	
	//---------Inq Types
	
	public static final String SELECT_ALL_INQ_TYPES = 
		"SELECT * FROM TBL_INQ_TYPES";
	
	//-----------Product
	
	public static final String SELECT_ALL_PRODUCTS =
		"SELECT * FROM TBL_PRODUCTS";
	
	
}
